package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:24
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysResourcePropertyDAOQueryBean extends BaseQueryBean {
    public SysResourcePropertyDAOQueryBean() {
        super();
    }

    public SysResourcePropertyDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysResourcePropertyDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.Id, "id");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.Remarks, "remarks");
        }
    }

    public void addResourcePropertyCodeSelectProperty() {
        addResourcePropertyCodeSelectProperty("resourcePropertyCode");
    }

    public void addResourcePropertyCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyCode,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyCode,
                "resourcePropertyCode");
        }
    }

    public void addResourcePropertyDefaultValueSelectProperty() {
        addResourcePropertyDefaultValueSelectProperty(
            "resourcePropertyDefaultValue");
    }

    public void addResourcePropertyDefaultValueSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyDefaultValue,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyDefaultValue,
                "resourcePropertyDefaultValue");
        }
    }

    public void addResourcePropertyNameSelectProperty() {
        addResourcePropertyNameSelectProperty("resourcePropertyName");
    }

    public void addResourcePropertyNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyName,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyName,
                "resourcePropertyName");
        }
    }

    public void addResourcePropertyOrderSelectProperty() {
        addResourcePropertyOrderSelectProperty("resourcePropertyOrder");
    }

    public void addResourcePropertyOrderSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyOrder,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyOrder,
                "resourcePropertyOrder");
        }
    }

    public void addResourcePropertyTypeSelectProperty() {
        addResourcePropertyTypeSelectProperty("resourcePropertyType");
    }

    public void addResourcePropertyTypeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyType,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyType,
                "resourcePropertyType");
        }
    }

    public void addResourcePropertyValueSelectProperty() {
        addResourcePropertyValueSelectProperty("resourcePropertyValue");
    }

    public void addResourcePropertyValueSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyValue,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.ResourcePropertyValue,
                "resourcePropertyValue");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.Status, "status");
        }
    }

    public void addSysResourceIdSelectProperty() {
        addSysResourceIdSelectProperty("sysResourceId");
    }

    public void addSysResourceIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyDAO.SysResourceId, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyDAO.SysResourceId,
                "sysResourceId");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addRemarksSelectProperty();

        addResourcePropertyCodeSelectProperty();

        addResourcePropertyDefaultValueSelectProperty();

        addResourcePropertyNameSelectProperty();

        addResourcePropertyOrderSelectProperty();

        addResourcePropertyTypeSelectProperty();

        addResourcePropertyValueSelectProperty();

        addStatusSelectProperty();

        addSysResourceIdSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysResourcePropertyDAOQueryBean> {
        protected Criteria(SysResourcePropertyDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysResourcePropertyDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.Id + " is not null AND " +
                ISysResourcePropertyDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.Id + " is null OR " +
                ISysResourcePropertyDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " is null OR " +
                ISysResourcePropertyDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " not in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " not in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Id + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysResourcePropertyDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysResourcePropertyDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysResourcePropertyDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysResourcePropertyDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysResourcePropertyDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.Remarks + " is not null AND " +
                ISysResourcePropertyDAO.Remarks + " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.Remarks +
                " is null OR " + ISysResourcePropertyDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " = ", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " <>", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " is null OR " +
                ISysResourcePropertyDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " >", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " >=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " <", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " <=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Remarks + " in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Remarks + " not in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyDAO.Remarks + " not between",
                value1, value2, "remarks");

            return this;
        }

        public Criteria andResourcePropertyCodeIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyCodeIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyCodeIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyCode + " <> ''");

            return this;
        }

        public Criteria andResourcePropertyCodeIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.ResourcePropertyCode +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyCode +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyCodeEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " = ",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " <>",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyCode +
                " <>", value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " >",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " >=",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " <",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " <=",
                value, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " like", buffer.toString(), "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " not like", buffer.toString(), "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                    " in", values, "resourcePropertyCode");

                return this;
            }
        }

        public Criteria andResourcePropertyCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                    " not in", values, "resourcePropertyCode");

                return this;
            }
        }

        public Criteria andResourcePropertyCodeIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                    " in", Arrays.asList(values), "resourcePropertyCode");

                return this;
            }
        }

        public Criteria andResourcePropertyCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                    " not in", Arrays.asList(values), "resourcePropertyCode");

                return this;
            }
        }

        public Criteria andResourcePropertyCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyCodeBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " between", value1, value2, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyCodeNotBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyCode +
                " not between", value1, value2, "resourcePropertyCode");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <> ''");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueIsEmpty() {
            addCriterion("(" +
                ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " is null OR " +
                ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " = ", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <>", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotEqualToOrIsNull(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " is null OR " +
                ISysResourcePropertyDAO.ResourcePropertyDefaultValue + " <>",
                value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " >", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " >=", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <=", value, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyDefaultValue);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " like", buffer.toString(), "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " not like", buffer.toString(), "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyDefaultValueEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                    " in", values, "resourcePropertyDefaultValue");

                return this;
            }
        }

        public Criteria andResourcePropertyDefaultValueNotIn(
            List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyDefaultValueNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                    " not in", values, "resourcePropertyDefaultValue");

                return this;
            }
        }

        public Criteria andResourcePropertyDefaultValueIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyDefaultValueEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                    " in", Arrays.asList(values), "resourcePropertyDefaultValue");

                return this;
            }
        }

        public Criteria andResourcePropertyDefaultValueNotIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyDefaultValueNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                    " not in", Arrays.asList(values),
                    "resourcePropertyDefaultValue");

                return this;
            }
        }

        public Criteria andResourcePropertyDefaultValueIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyDefaultValueBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " between", value1, value2, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyDefaultValueNotBetween(
            String value1, String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyDefaultValue +
                " not between", value1, value2, "resourcePropertyDefaultValue");

            return this;
        }

        public Criteria andResourcePropertyNameIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyNameIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyNameIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyName + " <> ''");

            return this;
        }

        public Criteria andResourcePropertyNameIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.ResourcePropertyName +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyName +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyNameEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " = ",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " <>",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyName +
                " <>", value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " >",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " >=",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " <",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " <=",
                value, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " like", buffer.toString(), "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " not like", buffer.toString(), "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                    " in", values, "resourcePropertyName");

                return this;
            }
        }

        public Criteria andResourcePropertyNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                    " not in", values, "resourcePropertyName");

                return this;
            }
        }

        public Criteria andResourcePropertyNameIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyNameEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                    " in", Arrays.asList(values), "resourcePropertyName");

                return this;
            }
        }

        public Criteria andResourcePropertyNameNotIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                    " not in", Arrays.asList(values), "resourcePropertyName");

                return this;
            }
        }

        public Criteria andResourcePropertyNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyNameBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " between", value1, value2, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyNameNotBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyName +
                " not between", value1, value2, "resourcePropertyName");

            return this;
        }

        public Criteria andResourcePropertyOrderIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyOrderIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyOrderIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyOrder + " <> ''");

            return this;
        }

        public Criteria andResourcePropertyOrderIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.ResourcePropertyOrder +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyOrder +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyOrderEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " = ",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderNotEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " <>",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderNotEqualToOrIsNull(
            Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyOrder +
                " <>", value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThan(Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " >",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThanOrEqualTo(
            Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " >=",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderLessThan(Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " <",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderLessThanOrEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder + " <=",
                value, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyOrder);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyOrderLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderIn(List<Integer> values) {
            if (values.size() == 1) {
                return andResourcePropertyOrderEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                    " in", values, "resourcePropertyOrder");

                return this;
            }
        }

        public Criteria andResourcePropertyOrderNotIn(List<Integer> values) {
            if (values.size() == 1) {
                return andResourcePropertyOrderNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                    " not in", values, "resourcePropertyOrder");

                return this;
            }
        }

        public Criteria andResourcePropertyOrderIn(Integer[] values) {
            if (values.length == 1) {
                return andResourcePropertyOrderEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                    " in", Arrays.asList(values), "resourcePropertyOrder");

                return this;
            }
        }

        public Criteria andResourcePropertyOrderNotIn(Integer[] values) {
            if (values.length == 1) {
                return andResourcePropertyOrderNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                    " not in", Arrays.asList(values), "resourcePropertyOrder");

                return this;
            }
        }

        public Criteria andResourcePropertyOrderIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyOrderBetween(Integer value1,
            Integer value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " between", value1, value2, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyOrderNotBetween(Integer value1,
            Integer value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyOrder +
                " not between", value1, value2, "resourcePropertyOrder");

            return this;
        }

        public Criteria andResourcePropertyTypeIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyTypeIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyTypeIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyType + " <> ''");

            return this;
        }

        public Criteria andResourcePropertyTypeIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.ResourcePropertyType +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyType +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyTypeEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " = ",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " <>",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyType +
                " <>", value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " >",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " >=",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " <",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " <=",
                value, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyType);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyTypeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " like", buffer.toString(), "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " not like", buffer.toString(), "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyTypeEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                    " in", values, "resourcePropertyType");

                return this;
            }
        }

        public Criteria andResourcePropertyTypeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyTypeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                    " not in", values, "resourcePropertyType");

                return this;
            }
        }

        public Criteria andResourcePropertyTypeIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyTypeEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                    " in", Arrays.asList(values), "resourcePropertyType");

                return this;
            }
        }

        public Criteria andResourcePropertyTypeNotIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyTypeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                    " not in", Arrays.asList(values), "resourcePropertyType");

                return this;
            }
        }

        public Criteria andResourcePropertyTypeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyTypeBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " between", value1, value2, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyTypeNotBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyType +
                " not between", value1, value2, "resourcePropertyType");

            return this;
        }

        public Criteria andResourcePropertyValueIsNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " is null");

            return this;
        }

        public Criteria andResourcePropertyValueIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " is not null");

            return this;
        }

        public Criteria andResourcePropertyValueIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " is not null AND " +
                ISysResourcePropertyDAO.ResourcePropertyValue + " <> ''");

            return this;
        }

        public Criteria andResourcePropertyValueIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.ResourcePropertyValue +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyValue +
                " = '')");

            return this;
        }

        public Criteria andResourcePropertyValueEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " = ",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " <>",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " is null OR " + ISysResourcePropertyDAO.ResourcePropertyValue +
                " <>", value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " >",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " >=",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " <",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue + " <=",
                value, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.ResourcePropertyValue);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andResourcePropertyValueLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " like", buffer.toString(), "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " not like", buffer.toString(), "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyValueEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                    " in", values, "resourcePropertyValue");

                return this;
            }
        }

        public Criteria andResourcePropertyValueNotIn(List<String> values) {
            if (values.size() == 1) {
                return andResourcePropertyValueNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                    " not in", values, "resourcePropertyValue");

                return this;
            }
        }

        public Criteria andResourcePropertyValueIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyValueEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                    " in", Arrays.asList(values), "resourcePropertyValue");

                return this;
            }
        }

        public Criteria andResourcePropertyValueNotIn(String[] values) {
            if (values.length == 1) {
                return andResourcePropertyValueNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                    " not in", Arrays.asList(values), "resourcePropertyValue");

                return this;
            }
        }

        public Criteria andResourcePropertyValueIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andResourcePropertyValueBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " between", value1, value2, "resourcePropertyValue");

            return this;
        }

        public Criteria andResourcePropertyValueNotBetween(String value1,
            String value2) {
            addCriterion(ISysResourcePropertyDAO.ResourcePropertyValue +
                " not between", value1, value2, "resourcePropertyValue");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysResourcePropertyDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.Status + " is not null AND " +
                ISysResourcePropertyDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.Status + " is null OR " +
                ISysResourcePropertyDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " = ", value, "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " is null OR " +
                ISysResourcePropertyDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " >=", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyDAO.Status + " <=", value, "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.Status + " like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Status + " in", values,
                    "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.Status + " not in",
                    values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.Status + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyDAO.Status + " between", value1,
                value2, "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyDAO.Status + " not between",
                value1, value2, "status");

            return this;
        }

        public Criteria andSysResourceIdIsNull() {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " is null");

            return this;
        }

        public Criteria andSysResourceIdIsNotNull() {
            addCriterion(ISysResourcePropertyDAO.SysResourceId +
                " is not null");

            return this;
        }

        public Criteria andSysResourceIdIsNotEmpty() {
            addCriterion(ISysResourcePropertyDAO.SysResourceId +
                " is not null AND " + ISysResourcePropertyDAO.SysResourceId +
                " <> ''");

            return this;
        }

        public Criteria andSysResourceIdIsEmpty() {
            addCriterion("(" + ISysResourcePropertyDAO.SysResourceId +
                " is null OR " + ISysResourcePropertyDAO.SysResourceId +
                " = '')");

            return this;
        }

        public Criteria andSysResourceIdEqualTo(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " = ", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdNotEqualTo(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " <>", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdNotEqualToOrIsNull(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId +
                " is null OR " + ISysResourcePropertyDAO.SysResourceId + " <>",
                value, "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdGreaterThan(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " >", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdGreaterThanOrEqualTo(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " >=", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdLessThan(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " <", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdLessThanOrEqualTo(Long value) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " <=", value,
                "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyDAO.SysResourceId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourceIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdIn(List<Long> values) {
            if (values.size() == 1) {
                return andSysResourceIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.SysResourceId + " in",
                    values, "sysResourceId");

                return this;
            }
        }

        public Criteria andSysResourceIdNotIn(List<Long> values) {
            if (values.size() == 1) {
                return andSysResourceIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyDAO.SysResourceId + " not in",
                    values, "sysResourceId");

                return this;
            }
        }

        public Criteria andSysResourceIdIn(Long[] values) {
            if (values.length == 1) {
                return andSysResourceIdEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.SysResourceId + " in",
                    Arrays.asList(values), "sysResourceId");

                return this;
            }
        }

        public Criteria andSysResourceIdNotIn(Long[] values) {
            if (values.length == 1) {
                return andSysResourceIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyDAO.SysResourceId + " not in",
                    Arrays.asList(values), "sysResourceId");

                return this;
            }
        }

        public Criteria andSysResourceIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourceIdBetween(Long value1, Long value2) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId + " between",
                value1, value2, "sysResourceId");

            return this;
        }

        public Criteria andSysResourceIdNotBetween(Long value1, Long value2) {
            addCriterion(ISysResourcePropertyDAO.SysResourceId +
                " not between", value1, value2, "sysResourceId");

            return this;
        }
    }
}
